using System;
using System.Data;
using System.Runtime.Serialization;

namespace MinCultura.Sipa.DataAccess.AgentesArtes
 {
     /// <summary>
     /// A custom serializable dataset containing 
     /// </summary>

     [Serializable()]
     [System.ComponentModel.DesignerCategoryAttribute("code")]
      

	/// <summary>Class for handling datasets</summary>  
	public class AgentesUbicacionData : DataTable
	{
    ///
    /// Constants for table and fields mapping
    ///
		public const string ART_AGENTES_UBICACION_TABLE = "ART_AGENTES_UBICACION";
    
    public const string AGE_ID_FIELD = "AGE_ID";
    public const string BAS_ZOP_ID_FIELD = "BAS_ZOP_ID";
    public const string BAS_ZON_ID_FIELD = "BAS_ZON_ID";
    public const string AGE_OTRA_CIUDAD_UBICACION_FIELD = "AGE_OTRA_CIUDAD_UBICACION";
    public const string AGE_AREA_FIELD = "AGE_AREA";
    public const string AGE_DIRECCION_FIELD = "AGE_DIRECCION";
    public const string AGE_TIENE_TELEFONO_FIELD = "AGE_TIENE_TELEFONO";
    public const string AGE_TELEFONO_FIELD = "AGE_TELEFONO";
    public const string AGE_TIENE_FAX_FIELD = "AGE_TIENE_FAX";
    public const string AGE_FAX_FIELD = "AGE_FAX";
    public const string AGE_APARTADO_AEREO_FIELD = "AGE_APARTADO_AEREO";
    public const string AGE_TIENE_CORREO_ELECTRONICO_FIELD = "AGE_TIENE_CORREO_ELECTRONICO";
    public const string AGE_CORREO_ELECTRONICO_FIELD = "AGE_CORREO_ELECTRONICO";
    public const string AGE_PAGINA_WEB_FIELD = "AGE_PAGINA_WEB";
    public const string AGE_TIENE_CELULAR_FIELD = "AGE_TIENE_CELULAR";
	public const string AGE_CELULAR_FIELD = "AGE_CELULAR";
    
    protected AgentesUbicacionData(SerializationInfo info, StreamingContext context)
    {
    //
    }

    public AgentesUbicacionData()
    {
       BuildDataTables();
    }
     
    /// <summary>
    /// Creates the following datatables: Localidades
    /// </summary>
    private void BuildDataTables()
		{
			Columns.Add(AGE_ID_FIELD, typeof(System.Decimal));
			Columns[AGE_ID_FIELD].Caption = "Id Agente";

			Columns.Add(BAS_ZOP_ID_FIELD, typeof(System.Int32));
			Columns[BAS_ZOP_ID_FIELD].Caption = "Id Pais";

			Columns.Add(BAS_ZON_ID_FIELD, typeof(System.String));
			Columns[BAS_ZON_ID_FIELD].Caption = "Id Municipio";

			Columns.Add(AGE_OTRA_CIUDAD_UBICACION_FIELD, typeof(System.String));
			Columns[AGE_OTRA_CIUDAD_UBICACION_FIELD].Caption = "Otra Ciudad Ubicacion";

			Columns.Add(AGE_AREA_FIELD, typeof(System.String));
			Columns[AGE_AREA_FIELD].Caption = "Area Geografica";

			Columns.Add(AGE_DIRECCION_FIELD, typeof(System.String));
			Columns[AGE_DIRECCION_FIELD].Caption = "Direccion";

			Columns.Add(AGE_TIENE_TELEFONO_FIELD, typeof(System.String));
			Columns[AGE_TIENE_TELEFONO_FIELD].Caption = "Tiene Telefono";

			Columns.Add(AGE_TELEFONO_FIELD, typeof(System.String));
			Columns[AGE_TELEFONO_FIELD].Caption = "Telefono";

			Columns.Add(AGE_TIENE_FAX_FIELD, typeof(System.String));
			Columns[AGE_TIENE_FAX_FIELD].Caption = "Tiene Fax";

			Columns.Add(AGE_FAX_FIELD, typeof(System.String));
			Columns[AGE_FAX_FIELD].Caption = "Fax";

			Columns.Add(AGE_APARTADO_AEREO_FIELD, typeof(System.String));
			Columns[AGE_APARTADO_AEREO_FIELD].Caption = "Apartado Aereo";

			Columns.Add(AGE_TIENE_CORREO_ELECTRONICO_FIELD, typeof(System.String));
			Columns[AGE_TIENE_CORREO_ELECTRONICO_FIELD].Caption = "Tiene Correo Electronico";

			Columns.Add(AGE_CORREO_ELECTRONICO_FIELD, typeof(System.String));
			Columns[AGE_CORREO_ELECTRONICO_FIELD].Caption = "Correo Electronico";

			Columns.Add(AGE_PAGINA_WEB_FIELD, typeof(System.String));
			Columns[AGE_PAGINA_WEB_FIELD].Caption = "Pagina Web";

			Columns.Add(AGE_TIENE_CELULAR_FIELD, typeof (System.Int32));
			Columns[AGE_TIENE_CELULAR_FIELD].Caption = "Tiene Celular";

			Columns.Add(AGE_CELULAR_FIELD, typeof (System.String));
			Columns[AGE_CELULAR_FIELD].Caption = "Celular";

			TableName = ART_AGENTES_UBICACION_TABLE;
    }
        
    /// <summary>
	/// Add a new row to the table
	/// </summary>
	/// <param name="row">Dataset row
	public void addAgentesUbicacion(DataRow row)
	{
		this.Rows.Add(row);
	}    
        
 }    
  
}  
